USE [RD_SalesMart]
GO

/****** Object:  Index [PK_Sales_Star_FactsRebates]    Script Date: 08/13/2010 21:51:13 ******/
ALTER TABLE [dbo].[Sales_Star_FactsRebates] ADD  CONSTRAINT [PK_Sales_Star_FactsRebates] PRIMARY KEY CLUSTERED 
(
	[OrderNumber] ASC,
	[OrderNumberDocumentCompany] ASC,
	[LineNumber] ASC,
	[OrderTypeCode] ASC,
	[OrderSuffix] ASC,
	[TransactionType] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO

/****** Object:  Index [IX_FactsRebates_FactsExtID]    Script Date: 08/13/2010 21:50:51 ******/
CREATE NONCLUSTERED INDEX [IX_FactsRebates_FactsExtID] ON [dbo].[Sales_Star_FactsRebates] 
(
	[FactsExtID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1799]    Script Date: 08/13/2010 21:50:51 ******/
CREATE NONCLUSTERED INDEX [missing_index_1799] ON [dbo].[Sales_Star_FactsRebates] 
(
	[UnitPrice] ASC
)
INCLUDE ( [FactsExtID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

ALTER INDEX [missing_index_1799] ON [dbo].[Sales_Star_FactsRebates] DISABLE
GO

/****** Object:  Index [missing_index_676]    Script Date: 08/13/2010 21:50:51 ******/
CREATE NONCLUSTERED INDEX [missing_index_676] ON [dbo].[Sales_Star_FactsRebates] 
(
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[SourceID],
[Source],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderSuffix],
[LineNumber],
[TransactionType],
[UnitPrice],
[ForeignUnitPrice],
[InsertIndicator],
[InsertDate],
[ChangeIndicator],
[ChangeDate],
[DeleteIndicator],
[DeleteDate],
[PurgeDate]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


